Project Summary
AtliQ Mart, a leading retail chain in South India, operates over 50 supermarkets. During Diwali 2023 and Sankranti 2024, the company ran a massive promotional campaign on their AtliQ-branded products to drive sales. Now, the Sales Director wants to evaluate which promotions performed well and which did not, so the company can optimize its future promotional strategies.To provide these insights, I conducted an in-depth sales analysis using Power BI, enabling the leadership team to make data-driven decisions.
Objectives of the Analysis
The primary goal of this analysis was to assess promotion effectiveness across key sales performance metrics:1. Sales Performance by Store – Understanding revenue distribution across 50 supermarkets.
2. Impact of Festive Promotions – Comparing sales before, during, and after promotions.
3. Top-Performing vs. Underperforming Promotions – Identifying which promotions drove the highest ROI.
4. Category & Product-Level Sales Trends – Analyzing which product categories benefited the most.
5. Customer Purchase Behavior – Understanding if promotions led to repeat purchases.
Insights & Business Impact
📊 High-Performing Promotions → Identified the campaigns that led to the highest revenue spikes.📉 Underperforming Promotions → Discovered promotions that had minimal impact or led to losses.
🏪 Store-Level Trends → Determined which supermarkets benefited the most from festive discounts.
📦 Best-Selling Product Categories → Uncovered which AtliQ-branded products were most popular.
🔄 Repeat Purchase Trends → Measured if promotions led to long-term customer retention.
Why This Project is Valuable?
✅ Demonstrates Expertise in Retail Sales Analysis✅ Showcases Power BI Skills – Data Cleaning, Modeling, and Visualization
✅ Applies Advanced DAX for KPI Calculation
✅ Provides Actionable Insights for Business Strategy
Let's see the project and explore all its objectives and insights.
Power BI Report :